﻿<?xml version="1.0" encoding="utf-8" ?>
<statements>
  <select_usercount parameterClass="System.Collections.IDictionary">
     <![CDATA[
       select t.UserLogName,t.UserName,isnull(t.QuanXian,'') QuanXian
       from (select ROW_NUMBER() OVER(ORDER BY UserLogName) RowNumber,UserLogName,UserName,QuanXian
       from TBT_USER where 1=1 #query#) t
       where t.RowNumber < #prev# and t.RowNumber > #next#
     ]]>  
  </select_usercount>
  <select_user parameterClass="System.Collections.IDictionary">
    <![CDATA[
       select UserLogName,UserName,isnull(QuanXian,'') QuanXian
       from TBT_USER where 1=1 #query#
     ]]>
  </select_user>
  <select_guest>
    <![CDATA[
      select count(1) from Tbt_guest where 1=1
    ]]>  
  </select_guest>

  <insert_LogAndModular parameterClass="System.Collections.IDictionary">
    <![CDATA[
      insert into Tbt_LogAndModular(LogName,ModularId)
      values(#LogName#,#ModularId#)
    ]]>
  </insert_LogAndModular>
</statements>